SUPPORT / SAMPLES & SAS NOTES
Problem Note 54244: SAS® Merchandise Data Integration load fails with "ERROR: ORACLE execute error: ORA-01408: such column list already indexed."
 |  |  |  |
SAS Merchandise Data Integration fails to load on the second attempt of a product load due to pre-existing indexes. After an initial failure, on the second attempt the load might fail again because SAS Merchandise Data Integration does not check for indexes on certain tables.
When you set the update_hierarchy flag set to Y during a hierarchy load, SAS Merchandise Data Integration expects to create indexes on certain tables then drop the indexes after statistics have been gathered. If the first attempt at this load fails before indexes have been dropped, any attempt to reload the data fails and the following error is generated:
MPRINT(DB_INDEX_ADD): execute ( create index ... on maxdata.mplan_working_m_orphans (workplan_id,merch_level,merch_id) ) by mmx_db;
ERROR: ORACLE execute error: ORA-01408: such column list already indexed.
If this issue is encountered, drop the index from the table indicated in the log.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Financial Planning | Microsoft Windows Server 2008 for x64 | 6.1.3 M6 | |||
| Microsoft Windows Server 2008 R2 | 6.1.3 M6 | 6.6 | 9.4 TS1M2 | |||
| Microsoft Windows Server 2003 for x64 | 6.1.3 M6 | |||||
| Linux for x64 | 6.6 | 6.6 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 6.1.3 M6 | 6.6 | 9.4 TS1M2 | |||
| 64-bit Enabled Solaris | 6.1.3 M6 | 6.6 | 9.4 TS1M2 | |||